{smcl}
{com}{sf}{ul off}{txt}{.-}
      name:  {res}<unnamed>
       {txt}log:  {res}C:\Users\ga2203\Dropbox\CCyield\Replication_Regressions_Climate Change and Long-Run Discount Rates\output/regressions_transaction.smcl
  {txt}log type:  {res}smcl
 {txt}opened on:  {res} 7 Jan 2021, 09:13:22
{txt}
{com}. 
. use "output/transaction_regression_data", clear
{txt}
{com}. 
. * Create interactions
. 
. gen ln_index_zipcode_year       = ln(index_zipcode_year + 0.01)
{txt}(748 missing values generated)

{com}. gen ln_index_zipcode_year_uw6ft = uw6ft * ln_index_zipcode_year
{txt}(761 missing values generated)

{com}. 
. gen ln_index_zipcode_quarter       = ln(index_zipcode_quarter + 0.01)
{txt}(54,895 missing values generated)

{com}. gen ln_index_zipcode_quarter_uw6ft = uw6ft * ln_index_zipcode_quarter
{txt}(54,908 missing values generated)

{com}. 
. gen index_zipcode_year_uw6ft    = uw6ft * index_zipcode_year
{txt}(761 missing values generated)

{com}. gen index_zipcode_quarter_uw6ft = uw6ft * index_zipcode_quarter
{txt}(54,908 missing values generated)

{com}. 
. * Label
. label variable ln_index_zipcode_year    "ln(Index by Zip-Year)"
{txt}
{com}. label variable ln_index_zipcode_quarter "ln(Index by Zip-Quarter)"
{txt}
{com}. 
. label variable ln_index_zipcode_year_uw6ft    "Flood Zone x ln(Index by Zip-Year)"
{txt}
{com}. label variable ln_index_zipcode_quarter_uw6ft "Flood Zone x ln(Index by Zip-Quarter)"
{txt}
{com}. 
. label variable index_zipcode_year    "Index by Zip-Year"
{txt}
{com}. label variable index_zipcode_quarter "Index by Zip-Quarter"
{txt}
{com}. 
. label variable index_zipcode_year_uw6ft    "Flood Zone x Index by Zip-Year"
{txt}
{com}. label variable index_zipcode_quarter_uw6ft "Flood Zone x Index by Zip-Quarter"
{txt}
{com}. 
. label variable ln_transaction_price "ln(Transaction Price)"
{txt}
{com}. label variable uw6ft                "Flood Zone"
{txt}
{com}. 
. 
. eststo: reghdfe ln_transaction_price uw6ft ln_index_zipcode_year_uw6ft   , absorb(apt3 finishedsquarefeet_pct lotsizesquarefeet_pct prop_age_group remodel_age_group bedroomcnt bathroomcnt zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 4929 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 28 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 7,287,000
{txt}Absorbing 8 HDFE groups{col 51}F({res}   2{txt},{res}  88626{txt}){col 67}= {res}    217.27
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.5896
{txt}{col 51}Adj R-squared{col 67}= {res}    0.5845
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0007
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    88,627{txt}{col 51}Root MSE{col 67}= {res}    0.5937

{txt}{ralign 78:(Std. Err. adjusted for {res:88,627} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2} .0044289{col 26}{space 2} .0145287{col 37}{space 1}    0.30{col 46}{space 3}0.760{col 54}{space 4}-.0240473{col 67}{space 3} .0329051
{txt}ln_~ar_uw6ft {c |}{col 14}{res}{space 2}-.0237316{col 26}{space 2} .0050367{col 37}{space 1}   -4.71{col 46}{space 3}0.000{col 54}{space 4}-.0336034{col 67}{space 3}-.0138598
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 11.92848{col 26}{space 2} .0003089{col 37}{space 1} 3.9e+04{col 46}{space 3}0.000{col 54}{space 4} 11.92787{col 67}{space 3} 11.92908
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 24}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}            Absorbed FE{col 25}{c |} Categories{col 38} - Redundant{col 50}  = Num. Coefs{col 65}{c |}
{res}{col 1}{text}{hline 24}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}                   apt3{col 25}{c |}{space 1}        2{col 38}{space 1}        0{col 50}{result}{space 1}        2{col 64}{text} {col 65}{c |}
{res}{col 1}{text} finishedsquarefeet_pct{col 25}{c |}{space 1}       21{col 38}{space 1}        1{col 50}{result}{space 1}       20{col 64}{text} {col 65}{c |}
{res}{col 1}{text}  lotsizesquarefeet_pct{col 25}{c |}{space 1}       11{col 38}{space 1}        2{col 50}{result}{space 1}        9{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         prop_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}      remodel_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}             bedroomcnt{col 25}{c |}{space 1}        8{col 38}{space 1}        1{col 50}{result}{space 1}        7{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}            bathroomcnt{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         zip_quarter_fe{col 25}{c |}{space 1}    88642{col 38}{space 1}    88642{col 50}{result}{space 1}        0{col 64}{text}*{col 65}{c |}
{res}{col 1}{text}{hline 24}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
? = number of redundant parameters may be higher
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est1{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft ln_index_zipcode_quarter_uw6ft, absorb(apt3 finishedsquarefeet_pct lotsizesquarefeet_pct prop_age_group remodel_age_group bedroomcnt bathroomcnt zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 4669 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 28 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 7,233,113
{txt}Absorbing 8 HDFE groups{col 51}F({res}   2{txt},{res}  88070{txt}){col 67}= {res}    214.74
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.5900
{txt}{col 51}Adj R-squared{col 67}= {res}    0.5850
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0007
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    88,071{txt}{col 51}Root MSE{col 67}= {res}    0.5934

{txt}{ralign 78:(Std. Err. adjusted for {res:88,071} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2}  .014066{col 26}{space 2} .0129763{col 37}{space 1}    1.08{col 46}{space 3}0.278{col 54}{space 4}-.0113674{col 67}{space 3} .0394994
{txt}ln_~er_uw6ft {c |}{col 14}{res}{space 2}-.0202017{col 26}{space 2} .0044265{col 37}{space 1}   -4.56{col 46}{space 3}0.000{col 54}{space 4}-.0288776{col 67}{space 3}-.0115259
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 11.92709{col 26}{space 2} .0003108{col 37}{space 1} 3.8e+04{col 46}{space 3}0.000{col 54}{space 4} 11.92648{col 67}{space 3}  11.9277
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 24}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}            Absorbed FE{col 25}{c |} Categories{col 38} - Redundant{col 50}  = Num. Coefs{col 65}{c |}
{res}{col 1}{text}{hline 24}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}                   apt3{col 25}{c |}{space 1}        2{col 38}{space 1}        0{col 50}{result}{space 1}        2{col 64}{text} {col 65}{c |}
{res}{col 1}{text} finishedsquarefeet_pct{col 25}{c |}{space 1}       21{col 38}{space 1}        1{col 50}{result}{space 1}       20{col 64}{text} {col 65}{c |}
{res}{col 1}{text}  lotsizesquarefeet_pct{col 25}{c |}{space 1}       11{col 38}{space 1}        2{col 50}{result}{space 1}        9{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         prop_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}      remodel_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}             bedroomcnt{col 25}{c |}{space 1}        8{col 38}{space 1}        1{col 50}{result}{space 1}        7{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}            bathroomcnt{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         zip_quarter_fe{col 25}{c |}{space 1}    88086{col 38}{space 1}    88086{col 50}{result}{space 1}        0{col 64}{text}*{col 65}{c |}
{res}{col 1}{text}{hline 24}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
? = number of redundant parameters may be higher
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est2{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft ln_index_zipcode_year_uw6ft   , absorb(propertyid zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 3806691 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}note: {res}uw6ft{txt} is probably collinear with the fixed effects (all partialled-out values are close to zero; tol = 1.0e-09)
{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 57 iterations)
{res}{txt}note: uw6ft omitted because of collinearity
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 3,485,238
{txt}Absorbing 2 HDFE groups{col 51}F({res}   1{txt},{res}  77542{txt}){col 67}= {res}      9.16
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0025
{txt}{col 51}R-squared{col 67}= {res}    0.8506
{txt}{col 51}Adj R-squared{col 67}= {res}    0.7208
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0000
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    77,543{txt}{col 51}Root MSE{col 67}= {res}    0.4856

{txt}{ralign 78:(Std. Err. adjusted for {res:77,543} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
ln_~ar_uw6ft {c |}{col 14}{res}{space 2}-.0291751{col 26}{space 2} .0096376{col 37}{space 1}   -3.03{col 46}{space 3}0.002{col 54}{space 4}-.0480647{col 67}{space 3}-.0102854
{txt}{space 7}_cons {c |}{col 14}{res}{space 2}  11.8587{col 26}{space 2} .0025096{col 37}{space 1} 4725.29{col 46}{space 3}0.000{col 54}{space 4} 11.85378{col 67}{space 3} 11.86362
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 16}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}    Absorbed FE{col 17}{c |} Categories{col 30} - Redundant{col 42}  = Num. Coefs{col 57}{c |}
{res}{col 1}{text}{hline 16}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     propertyid{col 17}{c |}{space 1}  1543060{col 30}{space 1}        0{col 42}{result}{space 1}  1543060{col 56}{text} {col 57}{c |}
{res}{col 1}{text} zip_quarter_fe{col 17}{c |}{space 1}    77544{col 30}{space 1}    77544{col 42}{result}{space 1}        0{col 56}{text}*{col 57}{c |}
{res}{col 1}{text}{hline 16}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est3{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft ln_index_zipcode_quarter_uw6ft, absorb(propertyid zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 3794517 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}note: {res}uw6ft{txt} is probably collinear with the fixed effects (all partialled-out values are close to zero; tol = 1.0e-09)
{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 58 iterations)
{res}{txt}note: uw6ft omitted because of collinearity
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 3,443,265
{txt}Absorbing 2 HDFE groups{col 51}F({res}   1{txt},{res}  77024{txt}){col 67}= {res}      8.84
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0029
{txt}{col 51}R-squared{col 67}= {res}    0.8508
{txt}{col 51}Adj R-squared{col 67}= {res}    0.7209
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0000
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    77,025{txt}{col 51}Root MSE{col 67}= {res}    0.4857

{txt}{ralign 78:(Std. Err. adjusted for {res:77,025} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
ln_~er_uw6ft {c |}{col 14}{res}{space 2}-.0208174{col 26}{space 2} .0070021{col 37}{space 1}   -2.97{col 46}{space 3}0.003{col 54}{space 4}-.0345413{col 67}{space 3}-.0070934
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 11.85806{col 26}{space 2} .0018358{col 37}{space 1} 6459.31{col 46}{space 3}0.000{col 54}{space 4} 11.85446{col 67}{space 3} 11.86166
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 16}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}    Absorbed FE{col 17}{c |} Categories{col 30} - Redundant{col 42}  = Num. Coefs{col 57}{c |}
{res}{col 1}{text}{hline 16}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     propertyid{col 17}{c |}{space 1}  1525998{col 30}{space 1}        0{col 42}{result}{space 1}  1525998{col 56}{text} {col 57}{c |}
{res}{col 1}{text} zip_quarter_fe{col 17}{c |}{space 1}    77026{col 30}{space 1}    77026{col 42}{result}{space 1}        0{col 56}{text}*{col 57}{c |}
{res}{col 1}{text}{hline 16}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est4{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft index_zipcode_year_uw6ft      , absorb(apt3 finishedsquarefeet_pct lotsizesquarefeet_pct prop_age_group remodel_age_group bedroomcnt bathroomcnt zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 4929 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 28 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 7,287,000
{txt}Absorbing 8 HDFE groups{col 51}F({res}   2{txt},{res}  88626{txt}){col 67}= {res}    213.08
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.5896
{txt}{col 51}Adj R-squared{col 67}= {res}    0.5845
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0007
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    88,627{txt}{col 51}Root MSE{col 67}= {res}    0.5937

{txt}{ralign 78:(Std. Err. adjusted for {res:88,627} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2} .0862132{col 26}{space 2} .0062122{col 37}{space 1}   13.88{col 46}{space 3}0.000{col 54}{space 4} .0740374{col 67}{space 3} .0983891
{txt}ind~ar_uw6ft {c |}{col 14}{res}{space 2}-.2331671{col 26}{space 2} .0801078{col 37}{space 1}   -2.91{col 46}{space 3}0.004{col 54}{space 4}-.3901777{col 67}{space 3}-.0761566
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 11.92845{col 26}{space 2} .0003093{col 37}{space 1} 3.9e+04{col 46}{space 3}0.000{col 54}{space 4} 11.92784{col 67}{space 3} 11.92905
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 24}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}            Absorbed FE{col 25}{c |} Categories{col 38} - Redundant{col 50}  = Num. Coefs{col 65}{c |}
{res}{col 1}{text}{hline 24}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}                   apt3{col 25}{c |}{space 1}        2{col 38}{space 1}        0{col 50}{result}{space 1}        2{col 64}{text} {col 65}{c |}
{res}{col 1}{text} finishedsquarefeet_pct{col 25}{c |}{space 1}       21{col 38}{space 1}        1{col 50}{result}{space 1}       20{col 64}{text} {col 65}{c |}
{res}{col 1}{text}  lotsizesquarefeet_pct{col 25}{c |}{space 1}       11{col 38}{space 1}        2{col 50}{result}{space 1}        9{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         prop_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}      remodel_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}             bedroomcnt{col 25}{c |}{space 1}        8{col 38}{space 1}        1{col 50}{result}{space 1}        7{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}            bathroomcnt{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         zip_quarter_fe{col 25}{c |}{space 1}    88642{col 38}{space 1}    88642{col 50}{result}{space 1}        0{col 64}{text}*{col 65}{c |}
{res}{col 1}{text}{hline 24}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
? = number of redundant parameters may be higher
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est5{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft index_zipcode_year_uw6ft      , absorb(propertyid zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 3806691 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}note: {res}uw6ft{txt} is probably collinear with the fixed effects (all partialled-out values are close to zero; tol = 1.0e-09)
{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 57 iterations)
{res}{txt}note: uw6ft omitted because of collinearity
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 3,485,238
{txt}Absorbing 2 HDFE groups{col 51}F({res}   1{txt},{res}  77542{txt}){col 67}= {res}     10.29
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0013
{txt}{col 51}R-squared{col 67}= {res}    0.8506
{txt}{col 51}Adj R-squared{col 67}= {res}    0.7208
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0000
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    77,543{txt}{col 51}Root MSE{col 67}= {res}    0.4856

{txt}{ralign 78:(Std. Err. adjusted for {res:77,543} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
ind~ar_uw6ft {c |}{col 14}{res}{space 2}-.4017946{col 26}{space 2} .1252773{col 37}{space 1}   -3.21{col 46}{space 3}0.001{col 54}{space 4}-.6473374{col 67}{space 3}-.1562518
{txt}{space 7}_cons {c |}{col 14}{res}{space 2}  11.8684{col 26}{space 2} .0006572{col 37}{space 1} 1.8e+04{col 46}{space 3}0.000{col 54}{space 4} 11.86712{col 67}{space 3} 11.86969
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 16}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}    Absorbed FE{col 17}{c |} Categories{col 30} - Redundant{col 42}  = Num. Coefs{col 57}{c |}
{res}{col 1}{text}{hline 16}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     propertyid{col 17}{c |}{space 1}  1543060{col 30}{space 1}        0{col 42}{result}{space 1}  1543060{col 56}{text} {col 57}{c |}
{res}{col 1}{text} zip_quarter_fe{col 17}{c |}{space 1}    77544{col 30}{space 1}    77544{col 42}{result}{space 1}        0{col 56}{text}*{col 57}{c |}
{res}{col 1}{text}{hline 16}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est6{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft index_zipcode_quarter_uw6ft   , absorb(apt3 finishedsquarefeet_pct lotsizesquarefeet_pct prop_age_group remodel_age_group bedroomcnt bathroomcnt zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 4669 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 28 iterations)
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 7,233,113
{txt}Absorbing 8 HDFE groups{col 51}F({res}   2{txt},{res}  88070{txt}){col 67}= {res}    210.30
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.5900
{txt}{col 51}Adj R-squared{col 67}= {res}    0.5850
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0007
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    88,071{txt}{col 51}Root MSE{col 67}= {res}    0.5934

{txt}{ralign 78:(Std. Err. adjusted for {res:88,071} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2} .0848583{col 26}{space 2} .0058134{col 37}{space 1}   14.60{col 46}{space 3}0.000{col 54}{space 4}  .073464{col 67}{space 3} .0962525
{txt}ind~er_uw6ft {c |}{col 14}{res}{space 2}-.2100179{col 26}{space 2} .0708616{col 37}{space 1}   -2.96{col 46}{space 3}0.003{col 54}{space 4} -.348906{col 67}{space 3}-.0711298
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 11.92707{col 26}{space 2} .0003111{col 37}{space 1} 3.8e+04{col 46}{space 3}0.000{col 54}{space 4} 11.92646{col 67}{space 3} 11.92768
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 24}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}            Absorbed FE{col 25}{c |} Categories{col 38} - Redundant{col 50}  = Num. Coefs{col 65}{c |}
{res}{col 1}{text}{hline 24}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}                   apt3{col 25}{c |}{space 1}        2{col 38}{space 1}        0{col 50}{result}{space 1}        2{col 64}{text} {col 65}{c |}
{res}{col 1}{text} finishedsquarefeet_pct{col 25}{c |}{space 1}       21{col 38}{space 1}        1{col 50}{result}{space 1}       20{col 64}{text} {col 65}{c |}
{res}{col 1}{text}  lotsizesquarefeet_pct{col 25}{c |}{space 1}       11{col 38}{space 1}        2{col 50}{result}{space 1}        9{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         prop_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}      remodel_age_group{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}             bedroomcnt{col 25}{c |}{space 1}        8{col 38}{space 1}        1{col 50}{result}{space 1}        7{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}            bathroomcnt{col 25}{c |}{space 1}       16{col 38}{space 1}        1{col 50}{result}{space 1}       15{col 64}{text}?{col 65}{c |}
{res}{col 1}{text}         zip_quarter_fe{col 25}{c |}{space 1}    88086{col 38}{space 1}    88086{col 50}{result}{space 1}        0{col 64}{text}*{col 65}{c |}
{res}{col 1}{text}{hline 24}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
? = number of redundant parameters may be higher
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est7{txt} stored)

{com}. eststo: reghdfe ln_transaction_price uw6ft index_zipcode_quarter_uw6ft   , absorb(propertyid zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 3794517 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}note: {res}uw6ft{txt} is probably collinear with the fixed effects (all partialled-out values are close to zero; tol = 1.0e-09)
{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 58 iterations)
{res}{txt}note: uw6ft omitted because of collinearity
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 3,443,265
{txt}Absorbing 2 HDFE groups{col 51}F({res}   1{txt},{res}  77024{txt}){col 67}= {res}     16.28
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0001
{txt}{col 51}R-squared{col 67}= {res}    0.8508
{txt}{col 51}Adj R-squared{col 67}= {res}    0.7209
{txt}{col 51}Within R-sq.{col 67}= {res}    0.0000
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    77,025{txt}{col 51}Root MSE{col 67}= {res}    0.4857

{txt}{ralign 78:(Std. Err. adjusted for {res:77,025} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
ind~er_uw6ft {c |}{col 14}{res}{space 2}-.3671765{col 26}{space 2} .0910153{col 37}{space 1}   -4.03{col 46}{space 3}0.000{col 54}{space 4} -.545566{col 67}{space 3}-.1887871
{txt}{space 7}_cons {c |}{col 14}{res}{space 2} 11.86544{col 26}{space 2} .0004764{col 37}{space 1} 2.5e+04{col 46}{space 3}0.000{col 54}{space 4} 11.86451{col 67}{space 3} 11.86637
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 16}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}    Absorbed FE{col 17}{c |} Categories{col 30} - Redundant{col 42}  = Num. Coefs{col 57}{c |}
{res}{col 1}{text}{hline 16}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text}     propertyid{col 17}{c |}{space 1}  1525998{col 30}{space 1}        0{col 42}{result}{space 1}  1525998{col 56}{text} {col 57}{c |}
{res}{col 1}{text} zip_quarter_fe{col 17}{c |}{space 1}    77026{col 30}{space 1}    77026{col 42}{result}{space 1}        0{col 56}{text}*{col 57}{c |}
{res}{col 1}{text}{hline 16}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est8{txt} stored)

{com}. 
. 
. * Now for coefficients
. tostring bathroomcnt, gen(br_str) format(%4.1f)
{txt}br_str generated as {res:str4}

{com}. encode br_str, gen(br)
{txt}
{com}. eststo: reghdfe ln_transaction_price uw6ft ln_index_zipcode_year_uw6ft i.apt3 i.finishedsquarefeet_pct i.lotsizesquarefeet_pct ///
>                                                                                    i.prop_age_group i.remodel_age_group i.bedroomcnt i.br, ///
>                                                                                absorb(zip_quarter_fe) vce(cluster zip_quarter)
{res}{txt}(dropped 4929 {browse "http://scorreia.com/research/singletons.pdf":singleton observations})
{res}{txt}({browse "http://scorreia.com/research/hdfe.pdf":MWFE estimator} converged in 1 iterations)
{res}{txt}note: 99.lotsizesquarefeet_pct omitted because of collinearity
{res}
{txt}HDFE Linear regression{col 51}Number of obs{col 67}= {res} 7,287,000
{txt}Absorbing 1 HDFE group{col 51}F({res}  84{txt},{res}  88626{txt}){col 67}= {res}   5139.31
{txt}Statistics robust to heteroskedasticity{col 51}Prob > F{col 67}= {res}    0.0000
{txt}{col 51}R-squared{col 67}= {res}    0.5896
{txt}{col 51}Adj R-squared{col 67}= {res}    0.5845
{txt}{col 51}Within R-sq.{col 67}= {res}    0.3396
{txt}{col 1}Number of clusters ({res}zip_quarter{txt}) {col 30}= {res}    88,627{txt}{col 51}Root MSE{col 67}= {res}    0.5937

{txt}{ralign 78:(Std. Err. adjusted for {res:88,627} clusters in zip_quarter)}
{hline 13}{c TT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{col 14}{c |}{col 26}    Robust
{col 1}ln_transac~e{col 14}{c |}      Coef.{col 26}   Std. Err.{col 38}      t{col 46}   P>|t|{col 54}     [95% Con{col 67}f. Interval]
{hline 13}{c +}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{space 7}uw6ft {c |}{col 14}{res}{space 2} .0044289{col 26}{space 2} .0145287{col 37}{space 1}    0.30{col 46}{space 3}0.760{col 54}{space 4}-.0240473{col 67}{space 3} .0329051
{txt}ln_~ar_uw6ft {c |}{col 14}{res}{space 2}-.0237316{col 26}{space 2} .0050367{col 37}{space 1}   -4.71{col 46}{space 3}0.000{col 54}{space 4}-.0336034{col 67}{space 3}-.0138598
{txt}{space 6}1.apt3 {c |}{col 14}{res}{space 2} .0365476{col 26}{space 2} .0039904{col 37}{space 1}    9.16{col 46}{space 3}0.000{col 54}{space 4} .0287263{col 67}{space 3} .0443688
{txt}{space 12} {c |}
finisheds~ct {c |}
{space 10}2  {c |}{col 14}{res}{space 2} .1508847{col 26}{space 2} .0042561{col 37}{space 1}   35.45{col 46}{space 3}0.000{col 54}{space 4} .1425427{col 67}{space 3} .1592266
{txt}{space 10}3  {c |}{col 14}{res}{space 2} .2507855{col 26}{space 2} .0040675{col 37}{space 1}   61.66{col 46}{space 3}0.000{col 54}{space 4} .2428132{col 67}{space 3} .2587578
{txt}{space 10}4  {c |}{col 14}{res}{space 2} .3371578{col 26}{space 2} .0042045{col 37}{space 1}   80.19{col 46}{space 3}0.000{col 54}{space 4}  .328917{col 67}{space 3} .3453986
{txt}{space 10}5  {c |}{col 14}{res}{space 2} .4094547{col 26}{space 2} .0042704{col 37}{space 1}   95.88{col 46}{space 3}0.000{col 54}{space 4} .4010848{col 67}{space 3} .4178246
{txt}{space 10}6  {c |}{col 14}{res}{space 2} .4754299{col 26}{space 2} .0042597{col 37}{space 1}  111.61{col 46}{space 3}0.000{col 54}{space 4} .4670809{col 67}{space 3} .4837788
{txt}{space 10}7  {c |}{col 14}{res}{space 2} .5278841{col 26}{space 2} .0043097{col 37}{space 1}  122.49{col 46}{space 3}0.000{col 54}{space 4} .5194372{col 67}{space 3} .5363311
{txt}{space 10}8  {c |}{col 14}{res}{space 2} .5944611{col 26}{space 2} .0043475{col 37}{space 1}  136.74{col 46}{space 3}0.000{col 54}{space 4}   .58594{col 67}{space 3} .6029822
{txt}{space 10}9  {c |}{col 14}{res}{space 2} .6434642{col 26}{space 2} .0044205{col 37}{space 1}  145.56{col 46}{space 3}0.000{col 54}{space 4}    .6348{col 67}{space 3} .6521284
{txt}{space 9}10  {c |}{col 14}{res}{space 2}  .697172{col 26}{space 2} .0043747{col 37}{space 1}  159.36{col 46}{space 3}0.000{col 54}{space 4} .6885975{col 67}{space 3} .7057464
{txt}{space 9}11  {c |}{col 14}{res}{space 2} .7585375{col 26}{space 2} .0044104{col 37}{space 1}  171.99{col 46}{space 3}0.000{col 54}{space 4}  .749893{col 67}{space 3} .7671819
{txt}{space 9}12  {c |}{col 14}{res}{space 2} .8081859{col 26}{space 2} .0044005{col 37}{space 1}  183.66{col 46}{space 3}0.000{col 54}{space 4} .7995609{col 67}{space 3}  .816811
{txt}{space 9}13  {c |}{col 14}{res}{space 2} .8567896{col 26}{space 2} .0044001{col 37}{space 1}  194.72{col 46}{space 3}0.000{col 54}{space 4} .8481655{col 67}{space 3} .8654137
{txt}{space 9}14  {c |}{col 14}{res}{space 2} .9223194{col 26}{space 2} .0044559{col 37}{space 1}  206.99{col 46}{space 3}0.000{col 54}{space 4} .9135858{col 67}{space 3} .9310531
{txt}{space 9}15  {c |}{col 14}{res}{space 2} .9764406{col 26}{space 2} .0044919{col 37}{space 1}  217.38{col 46}{space 3}0.000{col 54}{space 4} .9676364{col 67}{space 3} .9852447
{txt}{space 9}16  {c |}{col 14}{res}{space 2} 1.036324{col 26}{space 2} .0045623{col 37}{space 1}  227.15{col 46}{space 3}0.000{col 54}{space 4} 1.027382{col 67}{space 3} 1.045266
{txt}{space 9}17  {c |}{col 14}{res}{space 2} 1.111261{col 26}{space 2} .0045666{col 37}{space 1}  243.34{col 46}{space 3}0.000{col 54}{space 4}  1.10231{col 67}{space 3} 1.120211
{txt}{space 9}18  {c |}{col 14}{res}{space 2} 1.197882{col 26}{space 2} .0047027{col 37}{space 1}  254.72{col 46}{space 3}0.000{col 54}{space 4} 1.188665{col 67}{space 3}   1.2071
{txt}{space 9}19  {c |}{col 14}{res}{space 2} 1.289721{col 26}{space 2} .0048229{col 37}{space 1}  267.42{col 46}{space 3}0.000{col 54}{space 4} 1.280268{col 67}{space 3} 1.299174
{txt}{space 9}20  {c |}{col 14}{res}{space 2} 1.507138{col 26}{space 2} .0053788{col 37}{space 1}  280.20{col 46}{space 3}0.000{col 54}{space 4} 1.496596{col 67}{space 3}  1.51768
{txt}{space 9}99  {c |}{col 14}{res}{space 2} .6408526{col 26}{space 2}  .008164{col 37}{space 1}   78.50{col 46}{space 3}0.000{col 54}{space 4} .6248513{col 67}{space 3} .6568539
{txt}{space 12} {c |}
lotsizesq~ct {c |}
{space 10}2  {c |}{col 14}{res}{space 2} .0650742{col 26}{space 2} .0032453{col 37}{space 1}   20.05{col 46}{space 3}0.000{col 54}{space 4} .0587135{col 67}{space 3}  .071435
{txt}{space 10}3  {c |}{col 14}{res}{space 2} .1004886{col 26}{space 2}  .003406{col 37}{space 1}   29.50{col 46}{space 3}0.000{col 54}{space 4} .0938129{col 67}{space 3} .1071643
{txt}{space 10}4  {c |}{col 14}{res}{space 2} .1103371{col 26}{space 2} .0033333{col 37}{space 1}   33.10{col 46}{space 3}0.000{col 54}{space 4} .1038039{col 67}{space 3} .1168703
{txt}{space 10}5  {c |}{col 14}{res}{space 2} .1138384{col 26}{space 2} .0034064{col 37}{space 1}   33.42{col 46}{space 3}0.000{col 54}{space 4} .1071619{col 67}{space 3} .1205149
{txt}{space 10}6  {c |}{col 14}{res}{space 2} .1101734{col 26}{space 2} .0034565{col 37}{space 1}   31.87{col 46}{space 3}0.000{col 54}{space 4} .1033987{col 67}{space 3}  .116948
{txt}{space 10}7  {c |}{col 14}{res}{space 2} .1350317{col 26}{space 2} .0033939{col 37}{space 1}   39.79{col 46}{space 3}0.000{col 54}{space 4} .1283796{col 67}{space 3} .1416838
{txt}{space 10}8  {c |}{col 14}{res}{space 2} .1476637{col 26}{space 2} .0035006{col 37}{space 1}   42.18{col 46}{space 3}0.000{col 54}{space 4} .1408026{col 67}{space 3} .1545248
{txt}{space 10}9  {c |}{col 14}{res}{space 2}  .112455{col 26}{space 2} .0041539{col 37}{space 1}   27.07{col 46}{space 3}0.000{col 54}{space 4} .1043134{col 67}{space 3} .1205965
{txt}{space 9}10  {c |}{col 14}{res}{space 2} .1453322{col 26}{space 2} .0041289{col 37}{space 1}   35.20{col 46}{space 3}0.000{col 54}{space 4} .1372397{col 67}{space 3} .1534248
{txt}{space 9}99  {c |}{col 14}{res}{space 2}        0{col 26}{txt}  (omitted)
{space 12} {c |}
prop_age_g~p {c |}
{space 10}5  {c |}{col 14}{res}{space 2} .0369019{col 26}{space 2} .0061238{col 37}{space 1}    6.03{col 46}{space 3}0.000{col 54}{space 4} .0248993{col 67}{space 3} .0489044
{txt}{space 9}10  {c |}{col 14}{res}{space 2} .0206315{col 26}{space 2} .0071876{col 37}{space 1}    2.87{col 46}{space 3}0.004{col 54}{space 4} .0065438{col 67}{space 3} .0347191
{txt}{space 9}15  {c |}{col 14}{res}{space 2} .0362989{col 26}{space 2} .0081138{col 37}{space 1}    4.47{col 46}{space 3}0.000{col 54}{space 4}  .020396{col 67}{space 3} .0522018
{txt}{space 9}20  {c |}{col 14}{res}{space 2} .0112389{col 26}{space 2} .0091576{col 37}{space 1}    1.23{col 46}{space 3}0.220{col 54}{space 4}  -.00671{col 67}{space 3} .0291877
{txt}{space 9}25  {c |}{col 14}{res}{space 2}-.0168637{col 26}{space 2} .0085048{col 37}{space 1}   -1.98{col 46}{space 3}0.047{col 54}{space 4} -.033533{col 67}{space 3}-.0001943
{txt}{space 9}30  {c |}{col 14}{res}{space 2}  -.02391{col 26}{space 2} .0089384{col 37}{space 1}   -2.67{col 46}{space 3}0.007{col 54}{space 4}-.0414292{col 67}{space 3}-.0063907
{txt}{space 9}35  {c |}{col 14}{res}{space 2}-.0197761{col 26}{space 2} .0096364{col 37}{space 1}   -2.05{col 46}{space 3}0.040{col 54}{space 4}-.0386632{col 67}{space 3}-.0008889
{txt}{space 9}40  {c |}{col 14}{res}{space 2}-.0075081{col 26}{space 2} .0097352{col 37}{space 1}   -0.77{col 46}{space 3}0.441{col 54}{space 4}-.0265891{col 67}{space 3} .0115729
{txt}{space 9}45  {c |}{col 14}{res}{space 2} .0282096{col 26}{space 2} .0093461{col 37}{space 1}    3.02{col 46}{space 3}0.003{col 54}{space 4} .0098913{col 67}{space 3} .0465279
{txt}{space 9}50  {c |}{col 14}{res}{space 2} .0231321{col 26}{space 2} .0093385{col 37}{space 1}    2.48{col 46}{space 3}0.013{col 54}{space 4} .0048288{col 67}{space 3} .0414354
{txt}{space 9}55  {c |}{col 14}{res}{space 2} .0359542{col 26}{space 2} .0093734{col 37}{space 1}    3.84{col 46}{space 3}0.000{col 54}{space 4} .0175823{col 67}{space 3} .0543261
{txt}{space 9}60  {c |}{col 14}{res}{space 2} .0599177{col 26}{space 2} .0095645{col 37}{space 1}    6.26{col 46}{space 3}0.000{col 54}{space 4} .0411715{col 67}{space 3}  .078664
{txt}{space 9}65  {c |}{col 14}{res}{space 2} .0696754{col 26}{space 2} .0099596{col 37}{space 1}    7.00{col 46}{space 3}0.000{col 54}{space 4} .0501546{col 67}{space 3} .0891962
{txt}{space 9}70  {c |}{col 14}{res}{space 2} .0503846{col 26}{space 2}  .009799{col 37}{space 1}    5.14{col 46}{space 3}0.000{col 54}{space 4} .0311785{col 67}{space 3} .0695906
{txt}{space 9}99  {c |}{col 14}{res}{space 2}  .175524{col 26}{space 2} .0364432{col 37}{space 1}    4.82{col 46}{space 3}0.000{col 54}{space 4} .1040956{col 67}{space 3} .2469524
{txt}{space 12} {c |}
remodel_ag~p {c |}
{space 10}5  {c |}{col 14}{res}{space 2}-.0478788{col 26}{space 2} .0059147{col 37}{space 1}   -8.09{col 46}{space 3}0.000{col 54}{space 4}-.0594716{col 67}{space 3} -.036286
{txt}{space 9}10  {c |}{col 14}{res}{space 2}-.0670819{col 26}{space 2} .0070592{col 37}{space 1}   -9.50{col 46}{space 3}0.000{col 54}{space 4}-.0809178{col 67}{space 3}-.0532459
{txt}{space 9}15  {c |}{col 14}{res}{space 2}  -.10667{col 26}{space 2} .0079906{col 37}{space 1}  -13.35{col 46}{space 3}0.000{col 54}{space 4}-.1223315{col 67}{space 3}-.0910084
{txt}{space 9}20  {c |}{col 14}{res}{space 2} -.135568{col 26}{space 2}  .008851{col 37}{space 1}  -15.32{col 46}{space 3}0.000{col 54}{space 4}-.1529158{col 67}{space 3}-.1182201
{txt}{space 9}25  {c |}{col 14}{res}{space 2} -.182321{col 26}{space 2} .0084854{col 37}{space 1}  -21.49{col 46}{space 3}0.000{col 54}{space 4}-.1989523{col 67}{space 3}-.1656896
{txt}{space 9}30  {c |}{col 14}{res}{space 2}-.2318318{col 26}{space 2} .0088974{col 37}{space 1}  -26.06{col 46}{space 3}0.000{col 54}{space 4}-.2492705{col 67}{space 3}-.2143931
{txt}{space 9}35  {c |}{col 14}{res}{space 2}-.2857242{col 26}{space 2} .0094784{col 37}{space 1}  -30.14{col 46}{space 3}0.000{col 54}{space 4}-.3043017{col 67}{space 3}-.2671467
{txt}{space 9}40  {c |}{col 14}{res}{space 2}-.3359386{col 26}{space 2} .0095168{col 37}{space 1}  -35.30{col 46}{space 3}0.000{col 54}{space 4}-.3545914{col 67}{space 3}-.3172859
{txt}{space 9}45  {c |}{col 14}{res}{space 2}-.3399225{col 26}{space 2}  .009421{col 37}{space 1}  -36.08{col 46}{space 3}0.000{col 54}{space 4}-.3583875{col 67}{space 3}-.3214575
{txt}{space 9}50  {c |}{col 14}{res}{space 2} -.308582{col 26}{space 2} .0094537{col 37}{space 1}  -32.64{col 46}{space 3}0.000{col 54}{space 4}-.3271111{col 67}{space 3}-.2900529
{txt}{space 9}55  {c |}{col 14}{res}{space 2}-.3093849{col 26}{space 2} .0094862{col 37}{space 1}  -32.61{col 46}{space 3}0.000{col 54}{space 4}-.3279779{col 67}{space 3} -.290792
{txt}{space 9}60  {c |}{col 14}{res}{space 2}-.3255255{col 26}{space 2} .0097185{col 37}{space 1}  -33.50{col 46}{space 3}0.000{col 54}{space 4}-.3445737{col 67}{space 3}-.3064774
{txt}{space 9}65  {c |}{col 14}{res}{space 2}-.3468468{col 26}{space 2} .0103281{col 37}{space 1}  -33.58{col 46}{space 3}0.000{col 54}{space 4}-.3670899{col 67}{space 3}-.3266038
{txt}{space 9}70  {c |}{col 14}{res}{space 2}-.4115006{col 26}{space 2} .0099483{col 37}{space 1}  -41.36{col 46}{space 3}0.000{col 54}{space 4}-.4309992{col 67}{space 3}-.3920019
{txt}{space 9}99  {c |}{col 14}{res}{space 2}-.3005144{col 26}{space 2} .0370656{col 37}{space 1}   -8.11{col 46}{space 3}0.000{col 54}{space 4}-.3731627{col 67}{space 3}-.2278661
{txt}{space 12} {c |}
{space 2}bedroomcnt {c |}
{space 10}1  {c |}{col 14}{res}{space 2} .1239652{col 26}{space 2} .0416053{col 37}{space 1}    2.98{col 46}{space 3}0.003{col 54}{space 4} .0424191{col 67}{space 3} .2055112
{txt}{space 10}2  {c |}{col 14}{res}{space 2} .2066758{col 26}{space 2}  .041432{col 37}{space 1}    4.99{col 46}{space 3}0.000{col 54}{space 4} .1254694{col 67}{space 3} .2878822
{txt}{space 10}3  {c |}{col 14}{res}{space 2} .2389898{col 26}{space 2} .0413975{col 37}{space 1}    5.77{col 46}{space 3}0.000{col 54}{space 4}  .157851{col 67}{space 3} .3201286
{txt}{space 10}4  {c |}{col 14}{res}{space 2} .1936477{col 26}{space 2} .0414053{col 37}{space 1}    4.68{col 46}{space 3}0.000{col 54}{space 4} .1124937{col 67}{space 3} .2748018
{txt}{space 10}5  {c |}{col 14}{res}{space 2} .1287075{col 26}{space 2} .0414688{col 37}{space 1}    3.10{col 46}{space 3}0.002{col 54}{space 4} .0474292{col 67}{space 3} .2099859
{txt}{space 10}6  {c |}{col 14}{res}{space 2}-.0087384{col 26}{space 2} .0417008{col 37}{space 1}   -0.21{col 46}{space 3}0.834{col 54}{space 4}-.0904716{col 67}{space 3} .0729948
{txt}{space 9}99  {c |}{col 14}{res}{space 2} .1712906{col 26}{space 2} .0414023{col 37}{space 1}    4.14{col 46}{space 3}0.000{col 54}{space 4} .0901425{col 67}{space 3} .2524388
{txt}{space 12} {c |}
{space 10}br {c |}
{space 8}0.5  {c |}{col 14}{res}{space 2} -.008087{col 26}{space 2} .0310559{col 37}{space 1}   -0.26{col 46}{space 3}0.795{col 54}{space 4}-.0689563{col 67}{space 3} .0527822
{txt}{space 8}1.0  {c |}{col 14}{res}{space 2}-.0489962{col 26}{space 2} .0126435{col 37}{space 1}   -3.88{col 46}{space 3}0.000{col 54}{space 4}-.0737774{col 67}{space 3}-.0242151
{txt}{space 8}1.5  {c |}{col 14}{res}{space 2}-.0480144{col 26}{space 2} .0127435{col 37}{space 1}   -3.77{col 46}{space 3}0.000{col 54}{space 4}-.0729916{col 67}{space 3}-.0230373
{txt}{space 8}2.0  {c |}{col 14}{res}{space 2} .0407448{col 26}{space 2} .0125623{col 37}{space 1}    3.24{col 46}{space 3}0.001{col 54}{space 4} .0161227{col 67}{space 3} .0653668
{txt}{space 8}2.5  {c |}{col 14}{res}{space 2} .0627234{col 26}{space 2} .0126031{col 37}{space 1}    4.98{col 46}{space 3}0.000{col 54}{space 4} .0380214{col 67}{space 3} .0874254
{txt}{space 8}3.0  {c |}{col 14}{res}{space 2} .1228478{col 26}{space 2} .0126256{col 37}{space 1}    9.73{col 46}{space 3}0.000{col 54}{space 4} .0981017{col 67}{space 3} .1475939
{txt}{space 8}3.5  {c |}{col 14}{res}{space 2} .1913302{col 26}{space 2} .0127956{col 37}{space 1}   14.95{col 46}{space 3}0.000{col 54}{space 4} .1662509{col 67}{space 3} .2164094
{txt}{space 8}4.0  {c |}{col 14}{res}{space 2} .2107702{col 26}{space 2} .0128659{col 37}{space 1}   16.38{col 46}{space 3}0.000{col 54}{space 4} .1855531{col 67}{space 3} .2359872
{txt}{space 8}4.5  {c |}{col 14}{res}{space 2} .3884629{col 26}{space 2}  .013329{col 37}{space 1}   29.14{col 46}{space 3}0.000{col 54}{space 4} .3623382{col 67}{space 3} .4145875
{txt}{space 8}5.0  {c |}{col 14}{res}{space 2} .4367864{col 26}{space 2} .0135373{col 37}{space 1}   32.27{col 46}{space 3}0.000{col 54}{space 4} .4102535{col 67}{space 3} .4633193
{txt}{space 8}5.5  {c |}{col 14}{res}{space 2} .6228722{col 26}{space 2} .0156524{col 37}{space 1}   39.79{col 46}{space 3}0.000{col 54}{space 4} .5921936{col 67}{space 3} .6535508
{txt}{space 8}6.0  {c |}{col 14}{res}{space 2} .6165864{col 26}{space 2}  .015723{col 37}{space 1}   39.22{col 46}{space 3}0.000{col 54}{space 4} .5857694{col 67}{space 3} .6474033
{txt}{space 8}6.5  {c |}{col 14}{res}{space 2} .8471189{col 26}{space 2} .0193948{col 37}{space 1}   43.68{col 46}{space 3}0.000{col 54}{space 4} .8091053{col 67}{space 3} .8851324
{txt}{space 8}7.0  {c |}{col 14}{res}{space 2} .7437168{col 26}{space 2} .0191468{col 37}{space 1}   38.84{col 46}{space 3}0.000{col 54}{space 4} .7061893{col 67}{space 3} .7812443
{txt}{space 7}99.0  {c |}{col 14}{res}{space 2} .0594288{col 26}{space 2} .0129069{col 37}{space 1}    4.60{col 46}{space 3}0.000{col 54}{space 4} .0341314{col 67}{space 3} .0847263
{txt}{space 12} {c |}
{space 7}_cons {c |}{col 14}{res}{space 2} 10.99998{col 26}{space 2} .0434852{col 37}{space 1}  252.96{col 46}{space 3}0.000{col 54}{space 4} 10.91475{col 67}{space 3} 11.08521
{txt}{hline 13}{c BT}{hline 11}{hline 11}{hline 9}{hline 8}{hline 13}{hline 12}
{res}
{txt}Absorbed degrees of freedom:
{res}{col 1}{text}{hline 16}{c TT}{hline 12}{hline 12}{hline 14}{hline 1}{c TRC}
{col 1}{text}    Absorbed FE{col 17}{c |} Categories{col 30} - Redundant{col 42}  = Num. Coefs{col 57}{c |}
{res}{col 1}{text}{hline 16}{c +}{hline 12}{hline 12}{hline 14}{hline 1}{c RT}
{col 1}{text} zip_quarter_fe{col 17}{c |}{space 1}    88642{col 30}{space 1}    88642{col 42}{result}{space 1}        0{col 56}{text}*{col 57}{c |}
{res}{col 1}{text}{hline 16}{c BT}{hline 12}{hline 12}{hline 14}{hline 1}{c BRC}
* = FE nested within cluster; treated as redundant for DoF computation
{res}{txt}({res}est9{txt} stored)

{com}. cap log close
{smcl}
{com}{sf}{ul off}